

<link rel="stylesheet" type="text/css" href="style.css" />

<?php
	// You can do anything with the data. Just think of the possibilities!
	include('conn.php');

	$strlen = strlen($_GET['content']);
	$display_count = $_GET['count'];

	$select = "select * from click_records where keyword like '%".$_GET['content']."%'";
	$res = mysql_query($select);
	$rec_count = mysql_num_rows($res);
    if($display_count)
	{
	  echo "There are <font color='red' size='3'>".$rec_count."</font> matching records found.Click Search to view result.";
	}
	else
	{
?>
    <center>   
<!--	<table class="sofT" cellspacing="0" border="1">
	<tr>
		<td colspan="5" class="helpHed" align="center">Search Result</td>
	</tr>
	<tr>
	   <td class='helpHed'>Id</td>
	   <td class='helpHed'>Keyword</td>
	   <td class='helpHed'>Advertiser id</td>
	   <td class='helpHed'>Click_date</td>
	   <td class='helpHed'>Click Count</td>
    </tr>-->
    <select id="sel1" size="5"  class="sofT"> 
<?php
	if($rec_count > 0)
	{
		while($data=mysql_fetch_array($res))
		{ 
//			echo "<tr>
//				  <td class='sup'>".$data['id']."</td>
//				  <td class='sup'>".$data['keyword']."</td>
//				  <td class='sup'>".$data['advertiser_id']."</td>
//				  <td class='sup'>".$data['click_date']."</td>
//				  <td class='sup'>".$data['clicks']."</td>
//			     </tr>";

echo "<option value=".$data['id']." class=sup>".$data['keyword']."</option>";

		}
               ?></select>
                <?php


        }else
		echo '<td colspan="5" align="center"><FONT SIZE="2" COLOR="red">No matching records found....!</FONT></td>';
  }
?>

</center>